home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Freelog Special Freeware 31
/
FreelogHS31.iso
/
ArgentCompta
/
FASTCAISSE
/
Setup FASTCAISSE.exe
/
{app}
/
A Faire41.SQL
< prev
next >
Wrap
Text File
|
2003-10-14
|
605b
|
26 lines
SET GENERATOR VERSION_BASE TO 41;
CREATE GENERATOR GENPK_BLOBS;
SET GENERATOR GENPK_BLOBS TO 5;
CREATE TABLE "BLOBS"
(
"INDX" INTEGER NOT NULL,
"TEXTE" BLOB SUB_TYPE TEXT SEGMENT SIZE 80,
PRIMARY KEY ("INDX")
);
CREATE TRIGGER "SETPK_BLOB" FOR "BLOBS"
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF (NEW."INDX" IS NULL) THEN
NEW."INDX" = GEN_ID(GENPK_BLOBS,1);
END
;
ALTER TABLE "CLIENTS" ADD INDX_COMMENTAIRE INTEGER;
ALTER TABLE "CLIENTS" ADD INDX_LISTE Integer;
ALTER TABLE "FOURNISSEURS" ADD INDX_COMMENTAIRE INTEGER;
ALTER TABLE "FOURNISSEURS" ADD INDX_LISTE Integer;